Quản lý nhân sự công ty bằng c# _ full source code
60.415 lượt xem;
- frmchonbcnv.cs
- QuanLyNhanSu /
- project /
1 using System;
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14
15 namespace QuanLyNhanSu
16 {
17 public partial class frmchonbcnv : RadForm
18 {
19 //khai báo biến toàn cục
20 public SqlConnection sc = frmMain.me.sql.connectSQL();
21 public SqlDataAdapter sda = new SqlDataAdapter();
22 public DataSet ds = new DataSet();
23 clsdmpb cphong = new clsdmpb();
24 clsDMTo cto = new clsDMTo();
25 static public string maphong = "";
26 static public string mato = "";
27 static public string manv = "";
28 public frmchonbcnv()
29 {
30 InitializeComponent();
31 cbophong.DataSource = cphong.taocombo();
32 cbophong.DisplayMember = "tbl_phongban.tenphong";
33 cbophong.ValueMember = "tbl_phongban.maphong";
34 }
35 //kiểm tra có tồn tại nhân viên nào thuộc tổ này hay không
36 private bool kiemtra(string maphong, string mato)
37 {
38 ds.Clear();
39 string sel = "select * from tbl_nhanvien where maphong ='" + maphong
40 + "' and mato ='" + mato + "'";
41 sc.Open();
42 SqlCommand scmd = new SqlCommand(sel, sc);
43 object o = scmd.ExecuteScalar();
44 sc.Close();
45 if (o != null)
46 return true;
47 else
48 return false;
49 }
50 //kiểm tra có tồn tại nhân viên nào thuộc tổ này hay không
51 private bool kiemtra(string maphong)
52 {
53 ds.Clear();
54 string sel = "select * from tbl_nhanvien where maphong ='" + maphong + "'";
55 sc.Open();
56 SqlCommand scmd = new SqlCommand(sel, sc);
57 object o = scmd.ExecuteScalar();
58 sc.Close();
59 if (o != null)
60 return true;
61 else
62 return false;
63 }
64 //kiểm tra xem nhân viên đó có trong bảng tbl_nhân viên hay không?
65 private bool kiemtranv(string manv)
66 {
67 ds.Clear();
68 string sel = "select * from tbl_nhanvien where manv ='" + manv + "'";
69 sc.Open();
70 SqlCommand scmd = new SqlCommand(sel, sc);
71 object o = scmd.ExecuteScalar();
72 sc.Close();
73 if (o != null)
74 return true;
75 else
76 return false;
77 }
78 //lấy ds nhân viên theo tổ đưa vào file xml;
79 static public DataSet bcnhanvien(string maphong, string mato)
80 {
81 SqlConnection sc = frmMain.me.sql.connectSQL();
82 SqlDataAdapter sda = new SqlDataAdapter();
83 DataSet ds = new DataSet();
84 ds.Clear();
85 sc.Open();
86 string sel = "select * from tbl_nhanvien where maphong ='" + maphong
87 + "' and mato ='" + mato + "'";
88 SqlCommand scmd = new SqlCommand(sel, sc);
89 sda.SelectCommand = scmd;
90 sda.Fill(ds, "nhanvien");
91 string sel1 = "select * from tbl_danhmucto";
92 SqlCommand scmd1 = new SqlCommand(sel1, sc);
93 sda.SelectCommand = scmd1;
94 sda.Fill(ds, "dmto");
95 string sel2 = "select * from tbl_phongban";
96 SqlCommand scmd2 = new SqlCommand(sel2, sc);
97 sda.SelectCommand = scmd2;
98 sda.Fill(ds, "phong");
99 string sel3 = "select * from tbl_dmchucvu";
100 SqlCommand scmd3 = new SqlCommand(sel3, sc);
101 sda.SelectCommand = scmd3;
102 sda.Fill(ds, "chucvu");
103 sc.Close();
104 ds.WriteXmlSchema("bcnhanvien.xml");
105 return ds;
106 }
107 //lấy ds nhân viên theo phòng đưa vào file xml;
108 static public DataSet bcnhanvien(string maphong)
109 {
110 SqlConnection sc = frmMain.me.sql.connectSQL();
111 SqlDataAdapter sda = new SqlDataAdapter();
112 DataSet ds = new DataSet();
113 ds.Clear();
114 sc.Open();
115 string sel = "select * from tbl_nhanvien where maphong ='" + maphong + "'";
116 SqlCommand scmd = new SqlCommand(sel, sc);
117 sda.SelectCommand = scmd;
118 sda.Fill(ds, "nhanvien");
119 string sel2 = "select * from tbl_phongban";
120 SqlCommand scmd2 = new SqlCommand(sel2, sc);
121 sda.SelectCommand = scmd2;
122 sda.Fill(ds, "phong");
123 string sel3 = "select * from tbl_dmchucvu";
124 SqlCommand scmd3 = new SqlCommand(sel3, sc);
125 sda.SelectCommand = scmd3;
126 sda.Fill(ds, "chucvu");
127 sc.Close();
128 ds.WriteXmlSchema("bcnhanvien.xml");
129 return ds;
130 }
131 //lấy lý lịch nhân viên đưa vào file xml;
132 static public DataSet lylichnv(string manv)
133 {
134 SqlConnection sc = frmMain.me.sql.connectSQL();
135 SqlDataAdapter sda = new SqlDataAdapter();
136 DataSet ds = new DataSet();
137 ds.Clear();
138 sc.Open();
139 //nhanvien
140 string sel = "select * from tbl_NhanVien where manv ='" + manv + "'";
141 SqlCommand scmd = new SqlCommand(sel, sc);
142 sda.SelectCommand = scmd;
143 sda.Fill(ds, "nhanvien");
144 //to
145 string sel1 = "select * from tbl_danhmucto";
146 SqlCommand scmd1 = new SqlCommand(sel1, sc);
147 sda.SelectCommand = scmd1;
148 sda.Fill(ds, "dmto");
149 //phongban
150 string sel2 = "select * from tbl_phongban";
151 SqlCommand scmd2 = new SqlCommand(sel2, sc);
152 sda.SelectCommand = scmd2;
153 sda.Fill(ds, "phong");
154 //chucvu
155 string sel3 = "select * from tbl_dmchucvu";
156 SqlCommand scmd3 = new SqlCommand(sel3, sc);
157 sda.SelectCommand = scmd3;
158 sda.Fill(ds, "chucvu");
159 //tongiao
160 string sel4 = "select * from tbl_DMtongiao";
161 SqlCommand scmd4 = new SqlCommand(sel4, sc);
162 sda.SelectCommand = scmd4;
163 sda.Fill(ds, "tongiao");
164 //dantoc
165 string sel5 = "select * from tbl_DMdantoc";
166 SqlCommand scmd5 = new SqlCommand(sel5, sc);
167 sda.SelectCommand = scmd5;
168 sda.Fill(ds, "dantoc");
169 sc.Close();
170 ds.WriteXmlSchema("HSNhanVien.xml");
171 return ds;
172
173 }
174 private void cbophong_SelectedIndexChanged(object sender, EventArgs e)
175 {
176 cboto.DataSource = cto.taocombo(cbophong.SelectedValue.ToString());
177 cboto.DisplayMember = "DanhMucto.tento";
178 cboto.ValueMember = "DanhMucto.mato";
179 cboto.Text = "";
180 }
181
182 private void cmdin_Click(object sender, EventArgs e)
183 {
184 if (cboto.Text.Trim() == "")
185 {
186 if (kiemtra(cbophong.SelectedValue.ToString()) == true)
187 {
188 maphong = cbophong.SelectedValue.ToString();
189 frmrptbcnhanvien f = new frmrptbcnhanvien();
190 f.MdiParent = this.MdiParent;
191 f.Show();
192 }
193 }
194 else if (cboto.Text.Trim() != "")
195 {
196 if (kiemtra(cbophong.SelectedValue.ToString(), cboto.SelectedValue.ToString()) == true)
197 {
198 maphong = cbophong.SelectedValue.ToString();
199 mato = cboto.SelectedValue.ToString();
200 frmrptbcnhanvien f = new frmrptbcnhanvien();
201 f.MdiParent = this.MdiParent;
202 f.Show();
203 }
204 }
205 maphong = ""; mato = "";
206 }
207
208 private void frmchonbcnv_Load(object sender, EventArgs e)
209 {
210 maphong = ""; mato = ""; manv = "";
211 }
212 }
213 }
2 using System.Collections.Generic;
3 using System.ComponentModel;
4 using System.Data;
5 using System.Drawing;
6 using System.Linq;
7 using System.Text;
8 using System.Windows.Forms;
9 using System.Data.SqlClient;
10 using Telerik.WinControls;
11 using Telerik.WinControls.UI;
12 using Telerik.Data;
13 using QuanLyNhanSu.Class;
14
15 namespace QuanLyNhanSu
16 {
17 public partial class frmchonbcnv : RadForm
18 {
19 //khai báo biến toàn cục
20 public SqlConnection sc = frmMain.me.sql.connectSQL();
21 public SqlDataAdapter sda = new SqlDataAdapter();
22 public DataSet ds = new DataSet();
23 clsdmpb cphong = new clsdmpb();
24 clsDMTo cto = new clsDMTo();
25 static public string maphong = "";
26 static public string mato = "";
27 static public string manv = "";
28 public frmchonbcnv()
29 {
30 InitializeComponent();
31 cbophong.DataSource = cphong.taocombo();
32 cbophong.DisplayMember = "tbl_phongban.tenphong";
33 cbophong.ValueMember = "tbl_phongban.maphong";
34 }
35 //kiểm tra có tồn tại nhân viên nào thuộc tổ này hay không
36 private bool kiemtra(string maphong, string mato)
37 {
38 ds.Clear();
39 string sel = "select * from tbl_nhanvien where maphong ='" + maphong
40 + "' and mato ='" + mato + "'";
41 sc.Open();
42 SqlCommand scmd = new SqlCommand(sel, sc);
43 object o = scmd.ExecuteScalar();
44 sc.Close();
45 if (o != null)
46 return true;
47 else
48 return false;
49 }
50 //kiểm tra có tồn tại nhân viên nào thuộc tổ này hay không
51 private bool kiemtra(string maphong)
52 {
53 ds.Clear();
54 string sel = "select * from tbl_nhanvien where maphong ='" + maphong + "'";
55 sc.Open();
56 SqlCommand scmd = new SqlCommand(sel, sc);
57 object o = scmd.ExecuteScalar();
58 sc.Close();
59 if (o != null)
60 return true;
61 else
62 return false;
63 }
64 //kiểm tra xem nhân viên đó có trong bảng tbl_nhân viên hay không?
65 private bool kiemtranv(string manv)
66 {
67 ds.Clear();
68 string sel = "select * from tbl_nhanvien where manv ='" + manv + "'";
69 sc.Open();
70 SqlCommand scmd = new SqlCommand(sel, sc);
71 object o = scmd.ExecuteScalar();
72 sc.Close();
73 if (o != null)
74 return true;
75 else
76 return false;
77 }
78 //lấy ds nhân viên theo tổ đưa vào file xml;
79 static public DataSet bcnhanvien(string maphong, string mato)
80 {
81 SqlConnection sc = frmMain.me.sql.connectSQL();
82 SqlDataAdapter sda = new SqlDataAdapter();
83 DataSet ds = new DataSet();
84 ds.Clear();
85 sc.Open();
86 string sel = "select * from tbl_nhanvien where maphong ='" + maphong
87 + "' and mato ='" + mato + "'";
88 SqlCommand scmd = new SqlCommand(sel, sc);
89 sda.SelectCommand = scmd;
90 sda.Fill(ds, "nhanvien");
91 string sel1 = "select * from tbl_danhmucto";
92 SqlCommand scmd1 = new SqlCommand(sel1, sc);
93 sda.SelectCommand = scmd1;
94 sda.Fill(ds, "dmto");
95 string sel2 = "select * from tbl_phongban";
96 SqlCommand scmd2 = new SqlCommand(sel2, sc);
97 sda.SelectCommand = scmd2;
98 sda.Fill(ds, "phong");
99 string sel3 = "select * from tbl_dmchucvu";
100 SqlCommand scmd3 = new SqlCommand(sel3, sc);
101 sda.SelectCommand = scmd3;
102 sda.Fill(ds, "chucvu");
103 sc.Close();
104 ds.WriteXmlSchema("bcnhanvien.xml");
105 return ds;
106 }
107 //lấy ds nhân viên theo phòng đưa vào file xml;
108 static public DataSet bcnhanvien(string maphong)
109 {
110 SqlConnection sc = frmMain.me.sql.connectSQL();
111 SqlDataAdapter sda = new SqlDataAdapter();
112 DataSet ds = new DataSet();
113 ds.Clear();
114 sc.Open();
115 string sel = "select * from tbl_nhanvien where maphong ='" + maphong + "'";
116 SqlCommand scmd = new SqlCommand(sel, sc);
117 sda.SelectCommand = scmd;
118 sda.Fill(ds, "nhanvien");
119 string sel2 = "select * from tbl_phongban";
120 SqlCommand scmd2 = new SqlCommand(sel2, sc);
121 sda.SelectCommand = scmd2;
122 sda.Fill(ds, "phong");
123 string sel3 = "select * from tbl_dmchucvu";
124 SqlCommand scmd3 = new SqlCommand(sel3, sc);
125 sda.SelectCommand = scmd3;
126 sda.Fill(ds, "chucvu");
127 sc.Close();
128 ds.WriteXmlSchema("bcnhanvien.xml");
129 return ds;
130 }
131 //lấy lý lịch nhân viên đưa vào file xml;
132 static public DataSet lylichnv(string manv)
133 {
134 SqlConnection sc = frmMain.me.sql.connectSQL();
135 SqlDataAdapter sda = new SqlDataAdapter();
136 DataSet ds = new DataSet();
137 ds.Clear();
138 sc.Open();
139 //nhanvien
140 string sel = "select * from tbl_NhanVien where manv ='" + manv + "'";
141 SqlCommand scmd = new SqlCommand(sel, sc);
142 sda.SelectCommand = scmd;
143 sda.Fill(ds, "nhanvien");
144 //to
145 string sel1 = "select * from tbl_danhmucto";
146 SqlCommand scmd1 = new SqlCommand(sel1, sc);
147 sda.SelectCommand = scmd1;
148 sda.Fill(ds, "dmto");
149 //phongban
150 string sel2 = "select * from tbl_phongban";
151 SqlCommand scmd2 = new SqlCommand(sel2, sc);
152 sda.SelectCommand = scmd2;
153 sda.Fill(ds, "phong");
154 //chucvu
155 string sel3 = "select * from tbl_dmchucvu";
156 SqlCommand scmd3 = new SqlCommand(sel3, sc);
157 sda.SelectCommand = scmd3;
158 sda.Fill(ds, "chucvu");
159 //tongiao
160 string sel4 = "select * from tbl_DMtongiao";
161 SqlCommand scmd4 = new SqlCommand(sel4, sc);
162 sda.SelectCommand = scmd4;
163 sda.Fill(ds, "tongiao");
164 //dantoc
165 string sel5 = "select * from tbl_DMdantoc";
166 SqlCommand scmd5 = new SqlCommand(sel5, sc);
167 sda.SelectCommand = scmd5;
168 sda.Fill(ds, "dantoc");
169 sc.Close();
170 ds.WriteXmlSchema("HSNhanVien.xml");
171 return ds;
172
173 }
174 private void cbophong_SelectedIndexChanged(object sender, EventArgs e)
175 {
176 cboto.DataSource = cto.taocombo(cbophong.SelectedValue.ToString());
177 cboto.DisplayMember = "DanhMucto.tento";
178 cboto.ValueMember = "DanhMucto.mato";
179 cboto.Text = "";
180 }
181
182 private void cmdin_Click(object sender, EventArgs e)
183 {
184 if (cboto.Text.Trim() == "")
185 {
186 if (kiemtra(cbophong.SelectedValue.ToString()) == true)
187 {
188 maphong = cbophong.SelectedValue.ToString();
189 frmrptbcnhanvien f = new frmrptbcnhanvien();
190 f.MdiParent = this.MdiParent;
191 f.Show();
192 }
193 }
194 else if (cboto.Text.Trim() != "")
195 {
196 if (kiemtra(cbophong.SelectedValue.ToString(), cboto.SelectedValue.ToString()) == true)
197 {
198 maphong = cbophong.SelectedValue.ToString();
199 mato = cboto.SelectedValue.ToString();
200 frmrptbcnhanvien f = new frmrptbcnhanvien();
201 f.MdiParent = this.MdiParent;
202 f.Show();
203 }
204 }
205 maphong = ""; mato = "";
206 }
207
208 private void frmchonbcnv_Load(object sender, EventArgs e)
209 {
210 maphong = ""; mato = ""; manv = "";
211 }
212 }
213 }